Data Sources and Targets Reference

The following is a list of built-in data sources supported by Pyramid. For information about how to configure data sources in the Admin tool, click here.

Pyramid also supports custom connectors, which can be configured in the Admin console.

  • Click here to learn about custom connectors.

Source

 

Direct Query

Target

Compatible with Pulse

Configuration

Access

 

 

 

Local file upload, or pointer to a shared file on a network drive

Amazon Athena

 

Requires setup and configuration in Administration

Amazon S3

   

Requires setup and configuration in Administration

Apache Drill ##

Requires setup and configuration in Administration

Apache Hive ##

Requires setup and configuration in Administration

Apache Presto

Requires setup and configuration in Administration

Azure Blob

 

 

Requires setup and configuration in Administration

Azure Synapse

 

Requires setup and configuration in Administration

Custom JDBC

 

 

Requires setup and configuration in Administration

ClickHouse

 

Requires setup and configuration in Administration

Databricks

 

 

Requires setup and configuration in Administration

DB2

Requires setup and configuration in Administration

DB2 AS400

Requires setup and configuration in Administration

Denodo

 

 

Requires setup and configuration in Administration

Exasol

Requires setup and configuration in Administration

Excel

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Facebook

 

 

 

Requires setup and configuration in Administration

Firebird

 

Requires setup and configuration in Administration

Glue (Datavard)

 

 

 

Requires setup and configuration in Administration

Google Analytics

     

Requires setup and configuration in Administration

Google BigQuery

 

Requires setup and configuration in Administration

Google Sheets

 

 

 

ID or URL address

Greenplum (Pivotal)

Requires setup and configuration in Administration

Impala

Requires setup and configuration in Administration

JSON

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

MariaDB

Requires setup and configuration in Administration

MS OLAP

 

Requires setup and configuration in Administration.

MS OLAP sources can be directly queried without any setup in Model.

MS Tabular

 

Includes Azure SSAS Tabular.

Requires setup and configuration in Administration.

Tabular sources can be directly queried without any setup in Model.

MS Tabular models can be built in Model by connecting to an SQL target, and then loading the model's metadata into a Tabular target.

Mongo BI CX ##

 

Requires setup and configuration in Administration

Multi Files

 

 

 

 

Enter the shared folder path and the files to include in the upload. Each file must have the same structure (columns).

Note: this data source is not available in the Community Edition.

MySQL

Requires setup and configuration in Administration

Neo4j

 

 

Requires setup and configuration in Administration

Neo4j BI Connector ##

 

 

Requires setup and configuration in Administration

Netezza ##

Requires setup and configuration in Administration

NetSuite##

 

Requires setup and configuration in Administration

OData

     

Requires configuration in the client (add the node to the Data Flow and enter the OData Service URL in the Properties panel)

ODBC

     

Requires setup and configuration in Administration - click here for details.

ODBC Direct

 

 

Requires setup and configuration in Administration - click Configure ODBC Serverfor details.

Oracle

Requires setup and configuration in Administration

PostgreSQL

Requires setup and configuration in Administration

Pyramid In Memory

 

 

Use Pyramid's in memory database as a datasource and/ or target. Click here to learn more.

Pyramid Queries

N/A

N/A

 

Use Pyramid reports (data discoveries) as a data source. Click here to learn more.

Python as a source

N/A

N/A

 

Only supported in Model Pro

R as a source

N/A

N/A

 

Only supported in Model Pro

Redshift

 

Requires setup and configuration in Administration

RSS

 

 

 

Add the Feed URL in the Properties panel

SalesForce

   

 

Requires setup and configuration in Administration

SAP BW

 

 

Requires setup and configuration in Administration.

Supports direct querying only - there is no option to build an ETL for SAP BW. Click here to learn more.

SAP HANA

Requires setup and configuration in Administration.

Both ETL and direct querying are supported for SAP HANA. Click here to learn more.

SAS Data Set

 

 

 

Local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL Address

SharePoint Lists

 

 

Requires setup and configuration in Administration

SingleStore

Requires setup and configuration in Administration

Snowflake

 

Requires setup and configuration in Administration

Spark

 

 

Requires setup and configuration in Administration

SQL Server

Requires setup and configuration in Administration

SQL Server Azure

 

Requires setup and configuration in Administration

Sybase / SAP

Requires setup and configuration in Administration - select Shared Folder property

Teradata

Requires setup and configuration in Administration

Text

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address. Select the encoding of the file. Supports both Fixed Width Column files, and Delimited files. Custom delimiters are supported - type the delimiter in the Delimiters window in the Properties panel.

Twitter

 

 

 

Requires setup and configuration in Administration

Vertica

Requires setup and configuration in Administration

XML

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

## These drivers are not bundled in the main installer as of 2020.24 for various reasons. Customers wishing to use them can download the connectors and upload them manually from the "Connectors Marketplace" found in the custom connector administrative interface.

Note: If users have rights, they can setup configurable data sources themselves directly from inside the data modeling tools.

Pass-through Direct Query

Pass-through datasources can be natively queried by Pyramid with direct queries. This means that the data does not need to be pre-processed or copied by Pyramid (or any other technology) before it can be queried by users.

  • Click here to learn more about direct querying.

Note: MS Analysis Services (OLAP and Tabular) can be directly queried using their existing cubes and tabular models.

MS SQLServer Index Usage

When text parameters are passed to queries, Pyramid matches the Text type, VARCHAR or NVARCHAR, of the target text fields. This enables the utilization of any indexes that are present against those target text fields providing enhanced query performance.

Data Targets

'Targets' in data preparation allows Pyramid to mash up data and WRITE the resulting database to the targeted technology and designated server. Given that Pyramid can write to a variety of data stacks, the targeting options give users a wide variety of options on where to build intermediate models and how to correct issues with their data before they start the analysis process.

  • Click here to learn more about targets.

Pulse

A number of datasources are compatible with Pulse. When connecting to a Pulse datasource, you may opt to directly query the datasource, or you may add select or multi-select nodes to perform data streaming.

  • Click here to learn more about Pulse, including how to configure Pulse nodes in the Admin console.